﻿USE SchoolManager;
IF OBJECT_ID (N'dbo.Student', N'U') IS NOT NULL
DROP TABLE dbo.Student;
CREATE TABLE [dbo].[Student] (
    [UniqueID]    UNIQUEIDENTIFIER NOT NULL,
    [FirstName]   NVARCHAR (50)    NOT NULL,
    [LastName]    NVARCHAR (50)    NOT NULL,
    [Age]         INT              NOT NULL,
    [TuitionOwed] MONEY            NULL
);
ALTER TABLE [dbo].[Student]
    ADD CONSTRAINT [PK_Student] PRIMARY KEY CLUSTERED ([UniqueID] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF);

